Questions tagged [google-sheets-import-csv]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
244 views

How to import only some of csv into Google Sheets [closed]

I'm trying to auto-import this huge csv file into Google Sheets, but when I use the importdata function, it tells me "Resource at URL contents exceeded maximum size." I'd like it to auto-...
Matthew's user avatar
  • 11
0 votes
2 answers
526 views

Using IMPORTDATA with a csv file with different numeric format than locale

I'm using IMPORTDATA to get some Crypto Rates. My Spreadsheet has Locale settings to Spain and the data from the csv have the numeric format of United States, so I'm getting wrong numbers. There's a ...
Juan Antonio Tubío's user avatar
3 votes
3 answers
980 views

File import into sheets is dropping necessary leading spaces

I have a configuration .txt file that I'm trying to upload into a new tab in an existing Google spreadsheet. I choose File>Import and select Insert new sheet(s), Detect automatically (there is no ...
kviLL's user avatar
  • 364
0 votes
2 answers
878 views

Google Sheets interpreting dates from CSV in a weird way

I'm opening a csv report in Google Sheets. The Google Drive preview shows the dates like this: When I open this file in Google Sheets the dates now look like this: And if I try and convert the date ...
Westicle's user avatar
1 vote
2 answers
2k views

Date fields that refuse to be parsed/formatted

I have some very mysterious date fields in a huge (600 000 records) CSV file which absolutely refuses to behave. They come up aligned left, and conditional formatting shows that they cannot be seen ...
Sharkfin's user avatar
0 votes
1 answer
2k views

Import a CSV file to Google Spreadsheets

I am trying to upload a CSV file and importing it to Google Spreadsheets. The file contains the following: hi,hello\r\nwelcome,to\r\npeaceful,world What I expect in the Google spreadsheet is: hi,...
Senduran's user avatar
10 votes
3 answers
6k views

Import CSV, show formatted hyperlinks, =Hyperlink(..,..)

Based on a csv import, I would like to show formatted hyperlinks. There is a formula =HYPERLINK( "www.google.com" ; "Search Google" ) that does this, but is there any way to include this in a csv ...
Jasper Duizendstra's user avatar
2 votes
2 answers
7k views

Is there a way to upload a .csv file to Google Docs using a Google Sheets as a template?

I am generating a .CSV file with an application. I then upload the .CSV file to Google Docs, which creates a Google Docs Spreadsheet which is "plain and white". I then have to manually format the .CSV ...
Edward Tanguay's user avatar