How to Insert Excel Spreadsheet Page Breaks using a CSV source file

%3CLINGO-SUB%20id%3D%22lingo-sub-2707351%22%20slang%3D%22en-US%22%3EHow%20to%20Insert%20Excel%20Spreadsheet%20Page%20Breaks%20using%20a%20CSV%20source%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2707351%22%20slang%3D%22en-US%22%3E%3CP%3EI%20output%20formatted%20CSV%20files%20from%20my%20data%20base%20programs%20and%20then%20load%20them%20into%20a%20PC%2FWin10%20MS%20Office%20365%20Excel%20spreadsheet%20to%20display%2C%20print%20and%20manipulate%20the%20exported%20data.%20I%20am%20looking%20for%20a%20way%20to%20insert%20page%20breaks%20into%20the%20source%20csv%20file%20that%20will%20cause%20Excel%20to%20insert%20page%20breaks%20at%20the%20lines%20specified%20from%20the%20CSV%20file.%20I%20want%20to%20avoid%20having%20to%20manually%20enter%20the%20page%20breaks%20in%20page_break_view%20if%20possible.%20Is%20there%20a%20way%20to%20achieve%20this%2C%20ie%2C%20is%20there%20an%20escape%20code%20that%20the%20CSV%20input%20interpreter%20will%20recognize%20as%20a%20page%20break%20insertion%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2707351%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2707848%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Insert%20Excel%20Spreadsheet%20Page%20Breaks%20using%20a%20CSV%20source%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2707848%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1143476%22%20target%3D%22_blank%22%3E%40murray_ruben%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20CSV%20file%20is%20a%20plain%20text%20file%20without%20any%20formatting%20information%3B%20as%20far%20as%20I%20know%20you%20cannot%20specify%20page%20breaks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I output formatted CSV files from my data base programs and then load them into a PC/Win10 MS Office 365 Excel spreadsheet to display, print and manipulate the exported data. I am looking for a way to insert page breaks into the source csv file that will cause Excel to insert page breaks at the lines specified from the CSV file. I want to avoid having to manually enter the page breaks in page_break_view if possible. Is there a way to achieve this, ie, is there an escape code that the CSV input interpreter will recognize as a page break insertion?

1 Reply

@murray_ruben 

A CSV file is a plain text file without any formatting information; as far as I know you cannot specify page breaks.