Ask Your Question

importing text files with newline delimiters

asked 2017-10-29 07:44:15 +0100

windyplayer gravatar image

updated 2017-10-29 07:47:42 +0100

I'd like to create a spreadsheet from a file that looks like this:

Text File

When I open the text file I see an option for OTHER delimiter, but don't know what to type in there to say NEW LINE or ENTER or whatever the term is that the import dialog uses.

I want the spreadsheet to look like this:

spread sheet

Thanks, wp Yes, and I am really really really really really not a robot... sigh

btw, this is what the doc says for the OTHER file. NOT very helpful, or are Non-Printing characters and control characters not supported


Separates data into columns using the custom separator that you specify. Note: The custom separator must also be contained in your data.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-10-29 09:29:00 +0100

Well, newline is unconditional row separator. You cannot use it as field delimiter.

You either have to preprocess your data in a text editor to convert each newline not preceeded by x into some other delimiter, or create a macro.

edit flag offensive delete link more



...or use formula like as =T(OFFSET($A$1;ROW()*4+0;0)) to convert plain table to table you want

JohnSUN gravatar imageJohnSUN ( 2017-10-29 10:11:17 +0100 )edit

answered 2018-02-09 14:39:09 +0100

This is my guide:

Thanks for the info in this thread, pointed me in the right direction :) I figure the reason you can use new line as a delimiter is that new line means "the end of the row" in csv speak.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-29 07:44:15 +0100

Seen: 3,155 times

Last updated: Feb 09 '18