# Importing CSV file
**URL:** https://community.stardog.com/t/importing-csv-file/2463
**Category:** Support
**Created:** [May 21, 2020, 1:38am UTC](https://community.stardog.com/t/importing-csv-file/2463 "2020-05-21T01:38:57Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@eren](https://community.stardog.com/u/eren)
#### Post date: [May 21, 2020, 1:38am UTC](https://community.stardog.com/t/importing-csv-file/2463/1 "2020-05-21T01:38:57Z")
I am trying to import a csv file, but I am getting this error below;
Can you please help me understand why?
---
### Author:  [@jess](https://community.stardog.com/u/jess)
#### Post date: [May 21, 2020, 1:42am UTC](https://community.stardog.com/t/importing-csv-file/2463/2 "2020-05-21T01:42:31Z")
Hi Eren,
We noticed a similar issue when a UTF-8 byte-order-mark is present in the first column of the CSV file when it's exported from Excel. Are you able to check this? Something like `hexdump` or `xxd` would be able to show you the physical bytes of the file.
Jess
---
### Author:  [@jess](https://community.stardog.com/u/jess)
#### Post date: [May 21, 2020, 1:48am UTC](https://community.stardog.com/t/importing-csv-file/2463/4 "2020-05-21T01:48:29Z")
Did you download the Excel file and export it to CSV?
---
### Author:  [@eren](https://community.stardog.com/u/eren)
#### Post date: [May 21, 2020, 1:49am UTC](https://community.stardog.com/t/importing-csv-file/2463/5 "2020-05-21T01:49:28Z")
Yes, I did download as excel and export it to csv
---
### Author:  [@jess](https://community.stardog.com/u/jess)
#### Post date: [May 21, 2020, 1:53am UTC](https://community.stardog.com/t/importing-csv-file/2463/6 "2020-05-21T01:53:04Z")
You will need to remove the first three bytes of the file. This is a known issue and will be fixed in an upcoming release.
Jess
---
### Author:  [@eren](https://community.stardog.com/u/eren)
#### Post date: [May 21, 2020, 2:00am UTC](https://community.stardog.com/t/importing-csv-file/2463/7 "2020-05-21T02:00:11Z")
I think I found a way around. If you export as MS-DOS comma separated, it works
thank you!
---
### Author:  [@jess](https://community.stardog.com/u/jess)
#### Post date: [May 21, 2020, 2:01am UTC](https://community.stardog.com/t/importing-csv-file/2463/8 "2020-05-21T02:01:06Z")
Glad it's working. Thanks for the update.
---
### Author:  [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)
#### Post date: [May 21, 2020, 2:03am UTC](https://community.stardog.com/t/importing-csv-file/2463/9 "2020-05-21T02:03:52Z")
I can’t tell from the error message if you’re running Linux or Windows. There are a bunch of ways to do it in Linux so I’ll just leave their SO post here.
>
If you’re on Windows you can open it in notepad++, set the encoding to utf8 and save the file.
Hope that helps.
---
### Author:  [@eren](https://community.stardog.com/u/eren)
#### Post date: [May 21, 2020, 2:09am UTC](https://community.stardog.com/t/importing-csv-file/2463/10 "2020-05-21T02:09:20Z")
For another file, I am getting this error below. Can you help me with this please? I saved as MS-DOS comma separated, but it is not working
---
### Author:  [@jess](https://community.stardog.com/u/jess)
#### Post date: [May 21, 2020, 2:10am UTC](https://community.stardog.com/t/importing-csv-file/2463/11 "2020-05-21T02:10:17Z")
Can you share the mappings file?
---
### Author:  [@eren](https://community.stardog.com/u/eren)
#### Post date: [May 21, 2020, 2:23am UTC](https://community.stardog.com/t/importing-csv-file/2463/13 "2020-05-21T02:23:45Z")
[employee.zip](https://community.stardog.com/uploads/short-url/aqNNm9sQOU3CW7ZwOzQegWAInrZ.zip) (172.6 KB)
---
### Author:  [@jess](https://community.stardog.com/u/jess)
#### Post date: [May 21, 2020, 2:23am UTC](https://community.stardog.com/t/importing-csv-file/2463/14 "2020-05-21T02:23:49Z")
Let me try with this file and figure out what's going on.
---
### Author:  [@eren](https://community.stardog.com/u/eren)
#### Post date: [May 21, 2020, 6:51pm UTC](https://community.stardog.com/t/importing-csv-file/2463/15 "2020-05-21T18:51:42Z")
Please let me know if you figure out how to import
---
### Author:  [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)
#### Post date: [May 21, 2020, 7:28pm UTC](https://community.stardog.com/t/importing-csv-file/2463/16 "2020-05-21T19:28:59Z")
I don't know exactly what's causing the problem but if you get rid of all the spaces in the header names you can successfully import your data. The following header line works
`Region,Employee_Code,Last_Name,Local_Date_of_Joining,Designation,Status,Market_Unit,SkillList,Location`
Interestingly there seems to be two space problems. There were two leading spaces before ` LAST NAME` that I removed and then got a different error. Then I replaced the remaining spaces with and underscore and was successful.
---
### Author:  [@eren](https://community.stardog.com/u/eren)
#### Post date: [May 21, 2020, 7:37pm UTC](https://community.stardog.com/t/importing-csv-file/2463/17 "2020-05-21T19:37:23Z")
Thank you. It is working now
---
### Author:  [@system](https://community.stardog.com/u/system)
#### Post date: [June 4, 2020, 7:49pm UTC](https://community.stardog.com/t/importing-csv-file/2463/18 "2020-06-04T19:49:09Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.