search

turbot / steampipe-plugin-csv

Use SQL to instantly query data from CSV files. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/csv
Apache License 2.0
19 stars 4 forks source link

byte order mark becomes space before first field in header when exporting from excel #5

Closed judell closed 2 years ago

judell commented 2 years ago

I think that's what's happening, anyway. When saving a sheet as CSV from Excel, my default is UTF-8. and if the first column header is "name" it becomes " name" in the schema.

My workaround: Save as CSV (MS-DOS). 😱

rajlearner17 commented 2 years ago

@judell Thanks for the feedback. We will check this out.

rajlearner17 commented 2 years ago

@judell I exported one of the google worksheets to CSV, could not replicate the same. Did you try with any MS Excel files? That might be causing the issue? I can give it a try from a windows PC / apple-store MS excel may be.

github-actions[bot] commented 2 years ago

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

github-actions[bot] commented 2 years ago

This issue was closed because it has been stalled for 90 days with no activity.